CSV File Structures (Product Records)
(Instant Accounts Plus users only)
|
Field |
Type |
Size |
Validation |
Precision |
Import Type |
|
Product Code |
Char |
30 |
Yes |
|
Standard / Extended |
|
Description |
Char |
60 |
|
|
Standard / Extended |
|
Tax Code |
Int |
2 |
T0 û T99 |
|
Standard / Extended |
|
Sales Price |
Double |
11 |
|
8 digits + 2 d.p. |
Standard / Extended |
|
Unit of Sale |
Char |
8 |
|
|
Standard / Extended |
|
Location |
Char |
16 |
|
|
Standard / Extended |
|
Nominal Code |
Char |
8 |
Lookup |
|
Standard / Extended |
|
Stock Category Number |
Int |
3 |
1 - 999 |
3 digits + 0 d.p. |
Standard / Extended |
|
Department No |
Int |
3 |
1 - 999 |
3 digits + 0 d.p. |
Standard / Extended |
|
Supplier Account Ref |
Char |
8 |
Lookup |
|
Standard / Extended |
|
Part Number |
Char |
16 |
|
|
Standard / Extended |
|
Item Type |
Int |
2 |
0 or 1 |
|
Extended |
|
Commodity Code |
Char |
30 |
|
|
Extended |
|
Weight |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
|
Stock Take Date |
Date |
10 |
Date |
|
Extended |
|
Quantity In Stock |
--- |
--- |
|
|
Not Included |
|
Cost Price |
--- |
--- |
|
|
Not Included |
|
Stock Take Quantity |
Double |
11 |
|
8 digits + 2 d.p. |
Extended |
|
Memo |
--- |
--- |
|
|
Not Included |
Related Topics